﻿CREATE PROCEDURE [Mapping].[AddTargetKey]
  @categoryId int,
  @KeyValue nvarchar(20),
  @KeyAlternateValue sql_variant = NULL,
  @description nvarchar(200) = NULL
AS
  INSERT INTO Mapping.TargetKey([Category], [KeyValue], [KeyAlternateValue], [Description])
    VALUES(@categoryId, @KeyValue, @KeyAlternateValue, @description)
RETURN @@IDENTITY
